<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">

<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html"; charset="iso-8859-1">
		<meta name="keywords" content="CS2REP">
		<meta name="author" content="CHARONWARE - www.casestudio.com">

		<link rel="stylesheet" type="text/css" media="screen" href="september.css" title="report">
		<link rel="stylesheet" type="text/css" media="print" href="september_print.css" title="report">
		<title>CASE Studio 2 - HTML Report</title>
	</head>

<body class="rightPage">
<div align="center"><center>
<div class="caption1 width770">Entity list</div><br><br> 
<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="770">
 
  <tr>
    <td class="tabhead" > Entity name    </td>    <td class="tabhead" > Entity type    </td>    <td class="tabhead" > Primary key    </td>    <td class="tabhead" > # attributes    </td>  </tr>
  <tr>
    <td class="tabdata" > balances    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > balance_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > balances_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > balance_version_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > biweeks_periods    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > biweek_period_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > biweeks_periods_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > biweek_period_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > blocked_distributions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > blocked_distribution_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > bushels_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > bushel_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > corn_futures    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > corn_future_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > corn_futures_distributions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > corn_future_distribution_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > corn_futures_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > corn_future_version_id    </td>    <td class="tabdata" > 9    </td>  </tr>
  <tr>
    <td class="tabdata" > corns_types    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > corn_type_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > costs_elements    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > cost_element_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > costs_plants    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > plant_version_id, corn_type_id, cost_element_id    </td>    <td class="tabdata" > 9    </td>  </tr>
  <tr>
    <td class="tabdata" > costs_po    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > credits_lines    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > credit_line_id    </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > currencies    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > currency_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > currencies_forms    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > object_id, currency_id, user_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > exchanges_rates    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > exchange_rate_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > exchanges_rates_versions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > month_period_version_id, currency_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > futures_periods    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > future_period_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > futures_periods_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > future_period_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > futures_types    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > future_type_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > grinds_distributions_priorities_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > grind_distribution_priority_version_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > grinds_distributions_settings_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > grind_distribution_setting_versions_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > instructions_attachments    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > instruction_attachment_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > instructions_forecasts    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > instruction_forecast_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > instructions_strategies    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > instruction_strategy_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > instructions_types    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > instruction_type_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > items_distributions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > corn_future_distribution_id, item_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > languages    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > language_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > logs    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > log_id    </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > manual_charges    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > manual_charge_id    </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > manual_charges_details    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > manual_charge_detail_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > manual_recurrent_charges    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > manual_recurrent_charge_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > monthly_distribution_per_plant    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > purchase_order_version_id, plant_version_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > months_periods    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > month_period_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > months_periods_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > month_period_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > objects    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > object_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > objects_types    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > object_type_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > plants    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > plant_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > plants_corns_types_processes_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > plant_corn_type_process_version_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > plants_distributions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > plant_distribution_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > plants_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > plant_version_id    </td>    <td class="tabdata" > 11    </td>  </tr>
  <tr>
    <td class="tabdata" > po_balances_versions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > balance_version_id, purchase_order_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > po_planned_reals    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > po_planned_real_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_instructions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_instruction_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_instructions_details    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_instruction_detail_id    </td>    <td class="tabdata" > 11    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_instructions_futures    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_instruction_future_id    </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_order_id    </td>    <td class="tabdata" > 9    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_costs    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > cost_element_id, purchase_order_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_costs_versions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > cost_element_id, purchase_order_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_futures    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > purchase_order_id, corn_future_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_futures_versions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > corn_future_version_id, purchase_order_version_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_spots    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_order_spot_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > purchases_orders_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > purchase_order_version_id    </td>    <td class="tabdata" > 12    </td>  </tr>
  <tr>
    <td class="tabdata" > realizeds_instructions    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > corn_future_id, purchase_instruction_future_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > regions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > region_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > regions_batches    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > region_batch_id    </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > regions_distributions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > region_distribution_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > regions_plants    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > region_id, plant_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > sap_corn_cost    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > sap_corn_factor    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 8    </td>  </tr>
  <tr>
    <td class="tabdata" > sap_corn_grind    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > sap_plant_inventory    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > sap_sales_forecast    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" >     </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > tables    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > table_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > transports    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > transport_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > transports_costs    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > cost_element_id, transport_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > units    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > unit_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > units_forms    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > object_id, user_id, unit_id    </td>    <td class="tabdata" > 3    </td>  </tr>
  <tr>
    <td class="tabdata" > users_languages    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > user_id, language_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > version_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_customers    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > customer_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_factors    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > plant_id, item_id, month_period_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_items    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > item_id    </td>    <td class="tabdata" > 2    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_plants_versions    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > plant_id    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_sales_forecast    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > customer_id, item_id, month_period_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_sap_corn_cost    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > month_period_id, plant_id, currency_id    </td>    <td class="tabdata" > 7    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_sap_corn_grind    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > month_period_id, plant_id    </td>    <td class="tabdata" > 5    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_sap_plant_inventory    </td>    <td class="tabdata" > dependent    </td>    <td class="tabdata" > month_period_id, plant_id    </td>    <td class="tabdata" > 6    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_transit_corn    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > po_number    </td>    <td class="tabdata" > 4    </td>  </tr>
  <tr>
    <td class="tabdata" > vw_users    </td>    <td class="tabdata" > independent    </td>    <td class="tabdata" > user_id    </td>    <td class="tabdata" > 1   </td>  </tr>
</table>

</center></div><br><br> 
</body></html>
